We find the orignal information for this project on Amber’s website here.

1 Introduction

This is a report and analysis on Seattle’s bicycle sharing trends. The data includes weather reports for the area, the station locations, as well as trips taken by cycle riders. Future explorations of this type of data could include investigating more extensively the usage and effectiveness of other public transportation for this area. This would serve to establish a better understanding of public transportation trends for Seattle. Interestingly enough, this transportation company (Pronto Cycle Sharing) has since dissolved and the data points that were collected from this company are from October 2014-August2016. Thus, the trends showcased by this dataset are not necessarily reflective of current bike sharing trends in Seattle.

1.1 Loading the Necessary Data

Data was downloaded and compiled from Kaggle . csv files for ā€œstation,ā€ ā€œtrip,ā€ and ā€œweatherā€ from the company ā€œPronto Cycle Sharingā€ were pulled from this site and used for this project.

2 Station Locations

Look how widespread the rental stations are all over Seattle (see Figure 2.1)!

  n_distinct(station_id)
1                     58
Seattle Bike Station Locations

Figure 2.1: Seattle Bike Station Locations

2.1 Locations (zoomed)

For optimal viewing, here are the station whereabouts with some zoom for location precision.

Closeup

Figure 2.2: Closeup

Look at all those stations! Its hard to believe this company managed to go out of business!

2.2 Current Dock Count

Station Bike Counts

Figure 2.3: Station Bike Counts

Quite a few bikes to choose from (as of August 2016)!

2.3 Change in Number of Bike Docks Per Station

Bikes Per Station

Figure 2.4: Bikes Per Station

11 stations lost bike docks, 39 docks stayed the same, 8 stations gained docks.

3 Number of Rides Per Day

Daily Riders

Figure 3.1: Daily Riders

People really like going on fall and spring rides multiple times a day. Can you blame them though, Seattle in the fall is remarkable (see below)!!!

4 Plotting trips per month (by season; excluding summer)

Trips by season, per month

Figure 4.1: Trips by season, per month

December, January, and February are coded as ā€œWinter,ā€ March, April, and May are coded as ā€œSpring,ā€ and September, October, and November are coded as ā€œFall.ā€ It is pretty obvious that usage would peak in the mid-fall, decline going into the winter months, and start a gradual increase as it transitions from winter into spring. Spring is the ultimate peak of bike riding peaking about early to mid-March.

5 Average Trip Duration

Conversions

Figure 5.1: Conversions

Not a huge amount of variance between the seasons and the amount of time spent on the average ride. This could also be due to the sheer expense of riding with Pronto in general for both members and nonmembers.

6 Number of Trips by Day of Week

Weekday Trips

Figure 6.1: Weekday Trips

Oddly enough, there is no day of the week that is consistently higher (even on the weekends). Obviously the summer has the highest level of riders, but otherwise, no a lot of distint trends from this plot.

7 Number of Trips Per Time of Day

Daily Trip Log

Figure 7.1: Daily Trip Log

People seem to most commonly use this service during the peak commuting hours (i.e.Ā 8am and 5pm). However, on the weekends, the peak is around mid-day.

8 Number of Trips by Member Type

Trips of Members v. Short-Term Pass Holder

Figure 8.1: Trips of Members v. Short-Term Pass Holder

As to be expected, members have much overall higher usage rates than short-term pass holders (24 hour pass or a 3 day pass are the two options for short-term). Short-term passes are likely most appropriate for tourists or people who are vacationing in Seattle.

The two plots almost mimic one another as far as usuage rates go - this is interesting because of the differentials between members and short-term passholders.

9 Trip Duration by Member Type

Members v. Short-Term Pass Holder

Figure 9.1: Members v. Short-Term Pass Holder

There are three different membership options: short term membership where you can pay $8 for 24 hours or $16 for 3 days, and long-term membership which requires payment of $85 for an annual membership.

At least 30 minutes is allocated for each ride for members; and depending on your membership status, different levels of fees are incurred for each additional 30 minutes. For short-term members, any additional time exceeding 30 minutes incurs a $2 fee for the first extra 30 minutes, and $5 for each 30 minutes following.Long-term members are actually allowed 45 minute bike rides and for each 30 minutes after that it is a $2 fee. (see Figure 9.1)!

Interesting that ride times peak around 10 minutes regardless of the type of member. And after 20 minutes, long-term members rides drop off drastically as compared to the gradual decrease in short-term member’s ride times. Perhaps long term members are using the bikes for a primary source of transportation to and from work - hence the significantly shorter ride times.

9.1 Cost of a Biking Trip

Trip Cost for Members v. Non-Members

Figure 9.2: Trip Cost for Members v. Non-Members

It is definitely worth it to be a member vs.Ā a nonmember, there are many associated costs if you aren’t (see Figure 9.2)!

10 Bicycle Sharing Member Demographics

Member Ages

Figure 10.1: Member Ages

Riders tend to be aged towards the upper 20s, but this number could be misleading because we don’t have any real identifiers for the users (i.e.Ā is one 20 year old taking 100 trips a day, or if there are a ton of 20 year olds using the service one time).

11 Temperature Variance In Seattle

11.1 Minimum Temperatures

[1] "2016-02-14"
Min. Temps

Figure 11.1: Min. Temps

Must not be acccounting for wind-chill. I feel like it gets colder than the low 20’s in Seattle!

11.2 Mean Temperatures

Mean. Temps

Figure 11.2: Mean. Temps

Looks like they have all 4 seasons, instead of just the ā€œperpetual rainā€ we always associate with Seattle.

11.3 Maximum Temperatures

Max Temps

Figure 11.3: Max Temps

It definitely gets hotter than I anticipated there. With temperatures close to 100 degrees, it sounds like we’re talking about a southern city vs.Ā one in the north-west hemisphere.

12 Local Weather Events

Frequency of Type of Weather

Figure 12.1: Frequency of Type of Weather

What a rainy city - I guess the rumors are true since it is the most frequent weather event following ā€œotherā€!!

13 Mean Temperature vs.Ā Number of Trips

Temperature and it's Relationship with Trip Number

Figure 13.1: Temperature and it’s Relationship with Trip Number

People like to ride when it’s not too hot, but also when it is not too cold. Additionally, for the purposes of this graph, the temperatures are rounded to the nearest 5 degrees Fahrenheit

13.1 Normalize the Temperature vs.Ā Number of Trips

Temperature and it's Relationship with Trip Number 2

Figure 13.2: Temperature and it’s Relationship with Trip Number 2

This chart shows a positive, linear relationship (standardized from the data from the previous chart) that shows the correlation between temperature and number of rides. Further reinforcing the fact that people are much more likely to ride when it is warm outside.

14 Precipitation vs.Ā Number of Trips

Rain Events and it's Relationship with Trip Number

Figure 14.1: Rain Events and it’s Relationship with Trip Number

This chart kind of speaks for itself as well, however, the more it rains, the less likely that people are willing to use the bicycle sharing system. However, rain does not seem to always impair people’s want/need to ride a bike, but it does have a rather dramatic impact.

15 Conclusion

Annnnnnnd that’s a wrap. Data from the doomed bike sharing system and a graphical analysis of it. Hope you enjoyed my recreation of this project intially done by Amber Thomas and my examination of it.